package com.vogue.supplymall.shop.domain.mapper;

import com.vogue.ssm.database.util.SqlLangDriver;
import com.vogue.supplymall.shop.domain.model.ProductAttrvalue;

import java.util.List;

import org.apache.ibatis.annotations.Lang;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * The interface ProductAttrvalue mapper.
 *
 * @Aouthor: gzl
 * @Date: Create in 2017-12-12
 */
@Mapper
public interface ProductAttrvalueMapper extends BaseMapper<ProductAttrvalue, Long> {
    /**
     * 根据syscodeid、typeid、matchid、productid得到品项属性分类的值
     */
	@Select("select * from product_attrvalue where syscodeid=#{arg0} and typeid=#{arg1} and matchid=#{arg2} and productid=#{arg3}")
	@Lang(SqlLangDriver.class)
	public List<ProductAttrvalue> findProductAttrvalueBySTMP(Long sysCodeId,int typeId,String matchId,Long productId);
	
}
